Set Sites Media Objects to display

Update MediaMaster set PublicAccess = 1
from MediaMaster MM
inner join MediaXrefs MX on MM.MediaMasterID = MX.MediaXrefID
where MX.TableId = 189

To unsubscribe, send an email to <a href="/cgi-bin/wa?LOGON=A3%3D1712%26L%3DTMSUSERS%26E%3Dbase64%26P%3D163491%26B%3D--_005_DM5PR07MB3852FEC2ACF8C30B34E1D4BFF8330DM5PR07MB3852namp_%26T%3Dtext%252Fplain%3B%2520name%3D%2522Globally%2520check%2520Public%2520Access%2520%2520for%2520Sites%2520Media.txt%2522%26N%3DGlobally%2520check%2520Public%2520Access%2520%2520for%2520Sites%2520Media.txt%26attachment%3Dq%26XSS%3D3" target="_parent" >[log in to unmask]</a> with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.